/*
Navicat MySQL Data Transfer

Source Server         : local_dev
Source Server Version : 50530
Source Host           : 127.0.0.1:3306
Source Database       : db_activiti

Target Server Type    : MYSQL
Target Server Version : 50530
File Encoding         : 65001

Date: 2016-12-14 10:39:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for leave
-- ----------------------------
DROP TABLE IF EXISTS `leave`;
CREATE TABLE `leave` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `PROCESS_INSTANCE_ID` varchar(255) DEFAULT NULL COMMENT '流程ID',
  `USER_ID` varchar(255) DEFAULT NULL COMMENT '工号',
  `START_TIME` datetime DEFAULT NULL COMMENT '开始时间',
  `END_TIME` datetime DEFAULT NULL COMMENT '结束时间',
  `LEAVE_TYPE` varchar(255) DEFAULT NULL COMMENT '假种',
  `REASON` varchar(255) DEFAULT NULL COMMENT '请假事由',
  `APPLY_TIME` datetime DEFAULT NULL COMMENT '申请时间',
  `REALITY_END_TIME` datetime DEFAULT NULL COMMENT '实际结束时间',
  `REALITY_START_TIME` datetime DEFAULT NULL COMMENT '实际开始时间',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='请假表';

-- ----------------------------
-- Records of act_id_group
-- ----------------------------
BEGIN;
INSERT INTO `act_id_group` (`ID_`, `REV_`, `NAME_`, `TYPE_`) VALUES ('admin', '1', '管理员', null);
INSERT INTO `act_id_group` (`ID_`, `REV_`, `NAME_`, `TYPE_`) VALUES ('deptLeader', '1', '部门经理', null);
INSERT INTO `act_id_group` (`ID_`, `REV_`, `NAME_`, `TYPE_`) VALUES ('generalManager', '1', '总经理', null);
INSERT INTO `act_id_group` (`ID_`, `REV_`, `NAME_`, `TYPE_`) VALUES ('hr', '1', '人事经理', null);
COMMIT;

-- ----------------------------
-- Records of act_id_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Records of act_id_membership
-- ----------------------------
BEGIN;
INSERT INTO `act_id_membership` (`USER_ID_`, `GROUP_ID_`) VALUES ('henry', 'admin');
INSERT INTO `act_id_membership` (`USER_ID_`, `GROUP_ID_`) VALUES ('andy', 'deptLeader');
INSERT INTO `act_id_membership` (`USER_ID_`, `GROUP_ID_`) VALUES ('kermit', 'deptLeader');
INSERT INTO `act_id_membership` (`USER_ID_`, `GROUP_ID_`) VALUES ('bill', 'generalManager');
INSERT INTO `act_id_membership` (`USER_ID_`, `GROUP_ID_`) VALUES ('jenny', 'hr');
COMMIT;

-- ----------------------------
-- Records of act_id_user
-- ----------------------------
BEGIN;
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('amy', '1', 'Amy', 'Zhang', 'amy@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('andy', '1', 'Andy', 'Zhao', 'andy@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('bill', '1', 'Bill', 'Zheng', 'bill@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('eric', '1', 'Eric', 'Li', 'eric@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('henry', '1', 'Henry', 'Yan', 'admin@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('jenny', '1', 'Jenny', 'Luo', 'hr@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('kermit', '1', 'Kermit', 'Miao', 'kermit@localhost', '000000', null);
INSERT INTO `act_id_user` (`ID_`, `REV_`, `FIRST_`, `LAST_`, `EMAIL_`, `PWD_`, `PICTURE_ID_`) VALUES ('tom', '1', 'Tom', 'Wang', 'tom@localhost', '000000', null);
COMMIT;
